package cn.edu.gsau.info.dao;


import cn.edu.gsau.info.models.Shenhe;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

public interface ShenHeDao extends BaseMapper<Shenhe> {
    @Select("SELECT * FROM tbl_shenhe WHERE recoreId=#{recoreId} AND shenHeTime=(SELECT MAX(shenHeTime) FROM tbl_shenhe WHERE recoreId=#{recoreId})")
    Shenhe findEndShenHe(long recoreId) ;
}
